<%@ include file="database_ini.jsp"%>


<%
	boolean error = false;

	String DROPID = request.getParameter("DROPID");
	String LOC = request.getParameter("LOC");
	String SKU = request.getParameter("SKU");
	String LOTTBALOE05 = request.getParameter("LOTTBALOE05");
	String QTY = request.getParameter("QTY");

	request.setAttribute("DROPID", DROPID);
	response.sendRedirect("index.jsp?DROPID=" + DROPID);
	/*********debug*/
	System.out.println("DROPID: " + DROPID);
	System.out.println("LOC: " + LOC);
	System.out.println("SKU: " + SKU);
	System.out.println("LOTTBALOE05: " + LOTTBALOE05);
	System.out.println("QTY: " + QTY);
	/**********/

	Statement st = null;

	st = conn.createStatement();
	st.executeUpdate("insert into CCDET (CCDROPID, LOC, SKU, LOTTBALOE05, QTY) VALUES ( '" + DROPID + "', '" +LOC + "', '"
	+ SKU + "' ,  '" + LOTTBALOE05 + "' ,  '" + QTY + "')");

	conn.close();
%>